home *** CD-ROM | disk | FTP | other *** search
/ Developer Source 8 / developer source - volume 8.iso / orinf / jul96 / scalf101.gif < prev    next >
Graphics Interchange Format  |  1997-01-16  |  21.6 KB  |  356x334  |  4-bit (16 colors)
   ocr: Rank Access Path Single TOWI by ROWID 2 Singie TOw by cluster join 3 Single rOw by hash cluster key with unique or primary key Single row by unique or primary key 5 Cluster join Hash cluster key 7 Indexed cluster key Composite key Single-column indexes 10 Bounded range search on indexed columns 11 Unbounded range search on indexed columns 12 Sort-merge join 13 MAX or MIN of indexed column 14 ORDER BY on indexed columns 15 Fuil table scan Figure 1: The rules for access path selection.